CREATE TABLE [dbo].[TTINTE_CNDE]
(
[CO_EMPR] [dbo].[TD_VC_002] NOT NULL,
[NU_CNTB_EMPR] [dbo].[TD_IN_001] NOT NULL CONSTRAINT [DF__TTINTE_CN__NU_CN__110B679F] DEFAULT ((0)),
[CO_UNID_CNTB] [dbo].[TD_VC_003] NOT NULL,
[CO_OPRC_CNTB] [dbo].[TD_VC_003] NOT NULL,
[NU_ANNO] [dbo].[TD_IN_004_ANOS] NOT NULL,
[NU_MESE] [dbo].[TD_IN_002_MESE] NOT NULL,
[NU_ASTO] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[NU_SECU] [dbo].[TD_IN_001] NOT NULL CONSTRAINT [DF__TTINTE_CN__NU_SE__13E7D44A] DEFAULT ((0)),
[CO_TIPO_OPER] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_CLAV_TAOR] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_TABL_ORIG] [int] NULL CONSTRAINT [DF__TTINTE_CN__CO_TA__14DBF883] DEFAULT ((0)),
[ST_FLAG] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[ST_IMPR_CHEQ] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_PROC_SECU] [int] NULL CONSTRAINT [DF__TTINTE_CN__NU_PR__15D01CBC] DEFAULT ((0)),
[ST_OTRS] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[NU_ASTO_ORIG] [varchar] (10) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_OPRC_ORIG] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_UNID_ORIG] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SI_MVTO_DOCU] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[SI_MVTO_CNTB] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_ORDE_SERV] [varchar] (50) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FE_PROG_CHEQ] [datetime] NULL,
[FE_ENTR_CHEQ] [datetime] NULL,
[NO_GIRA] [dbo].[TD_VC_100] NULL,
[FE_DOCU_REFE] [datetime] NULL,
[NU_DOCU_REFE] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TI_DOCU_REFE] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[DE_GLOS] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[IM_MVTO_CNTB] [numeric] (16, 4) NULL CONSTRAINT [DF__TTINTE_CN__IM_MV__16C440F5] DEFAULT ((0)),
[IM_MVTO_ORIG] [numeric] (16, 4) NULL CONSTRAINT [DF__TTINTE_CN__IM_MV__17B8652E] DEFAULT ((0)),
[TI_OPER] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FA_CAMB_DIAR] [numeric] (9, 4) NULL CONSTRAINT [DF__TTINTE_CN__FA_CA__18AC8967] DEFAULT ((0)),
[FA_CAMB] [numeric] (9, 4) NOT NULL CONSTRAINT [DF__TTINTE_CN__FA_CA__19A0ADA0] DEFAULT ((0)),
[CO_MONE] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[TI_CAMB] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NOT NULL,
[FE_DOCU_VENC] [datetime] NULL,
[FE_DOCU] [datetime] NULL,
[NU_DOCU] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TI_DOCU] [varchar] (3) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_AUXI_EMPR] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[TI_AUXI_EMPR] [varchar] (1) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[CO_CNTA_EMPR] [varchar] (20) COLLATE SQL_Latin1_General_CP1_CI_AS NULL,
[FE_ASTO_CNTB] [datetime] NOT NULL,
[NU_PROC] [int] NOT NULL CONSTRAINT [DF__TTINTE_CN__NU_PR__1A94D1D9] DEFAULT ((0)),
[CO_USUA_CREA] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTINTE_CN__CO_US__1B88F612] DEFAULT (suser_sname()),
[FE_USUA_CREA] [datetime] NULL CONSTRAINT [DF__TTINTE_CN__FE_US__1C7D1A4B] DEFAULT (getdate()),
[FE_USUA_MODI] [datetime] NULL CONSTRAINT [DF__TTINTE_CN__FE_US__1D713E84] DEFAULT (getdate()),
[CO_USUA_MODI] [varchar] (8) COLLATE SQL_Latin1_General_CP1_CI_AS NULL CONSTRAINT [DF__TTINTE_CN__CO_US__1E6562BD] DEFAULT (suser_sname())
) ON [PRIMARY]
GO
ALTER TABLE [dbo].[TTINTE_CNDE] WITH NOCHECK ADD CONSTRAINT [CK__TTINTE_CN__NU_AN__11FF8BD8] CHECK NOT FOR REPLICATION (([NU_ANNO]>(1980)))
GO
ALTER TABLE [dbo].[TTINTE_CNDE] WITH NOCHECK ADD CONSTRAINT [CK__TTINTE_CN__NU_ME__12F3B011] CHECK NOT FOR REPLICATION (([NU_MESE]>=(0) AND [NU_MESE]<=(13)))
GO
ALTER TABLE [dbo].[TTINTE_CNDE] ADD CONSTRAINT [PK__TTINTE_C__0DAAD33C5130D9AC] PRIMARY KEY CLUSTERED  ([CO_EMPR], [NU_CNTB_EMPR], [CO_UNID_CNTB], [CO_OPRC_CNTB], [NU_ANNO], [NU_MESE], [NU_ASTO], [NU_SECU]) ON [PRIMARY]
GO
